﻿CREATE TYPE [flcr].[SUPPLIER_UDT] AS  TABLE (
    [SUPPLIER_ID]       INT           NULL,
    [AUDIT_USER]        VARCHAR (100) NULL,
    [AUDIT_DTTM]        DATETIME      NULL,
    [AUDIT_DTTM_TZ]     INT           NULL,
    [AUDIT_MOD_USER]    VARCHAR (100) NULL,
    [AUDIT_MOD_DTTM]    DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ] INT           NULL,
    [BUILTIN]           BIT           NULL,
    [WRKFL_STATUS_ID]   INT           NULL,
    [ACTIVE_FLG]        BIT           NULL,
    [SORT_ORDER]        INT           NULL,
    [SUPPLIER_NAME]     VARCHAR (100) NULL,
    [SUPPLIER_SNAME]    VARCHAR (50)  NULL,
    [SUPPLIER_DESC]     VARCHAR (MAX) NULL,
    [SUPPLIER_TYPE]     INT           NULL,
    [PARENT_ID]         INT           NULL);

